OData Feed
The OData feed function allows users to capture a special URL that allows them to read in the result set of the item's query into another client technology that consumes data. This, in effect, turns Pyramid into a data source - and should not be confused with the OData source option in Model, where Pyramid can consume other OData feeds.
The capability is limited to Discover reports.
The OData Feed capability requires separate licensing.
Accessing the OData Feed URL
The OData function can be triggered from using the quick action buttons on the Action Panel for relevant items (green circle below).
Alternatively it can also be accessed from an item's tab menu in the App Tab Interface (red arrow below).
To use Pyramid data inside another tool, like Excel, click the OData button. This will put the special URL into your clipboard's copy/paste memory.
Next, switch to Excel, and open a new worksheet. Go to the Data Tab, choose "Get Data" and then choose "From OData Feed" (orange arrow below).
In the pop-up dialog, paste the URL into the box (CTRL+V). Then Click OK.
You will likely be prompted to supply your user credentials to login to Pyramid to access the data source. Enter those as well.
You will then be prompted with a preview of the result set. Click Load to import the data.
Once imported, use the data as needed. At any time, right click on the table to refresh the data and re-pull updated results from Pyramid.